Release 10.1A: OpenEdge Development:
Progress 4GL Reference

DYNAMIC-CURRENT-VALUE function

Returns the current integer value of a sequence defined in the specified database.

Syntax

DYNAMIC-CURRENT-VALUE( sequence-expression, logical-dbname-expression )

sequence-expression

A character expression that evaluates to the name of a sequence.

logical-dbname-expression

A character expression that evaluates to the name of a connected database in which the sequence is defined.

Notes

If logical-dbname-expression contains the Unknown value (?), Progress generates a runtime error.
The user must have CAN-READ privileges on the _Sequence table to use the DYNAMIC-CURRENT-VALUE function.
The current value of a sequence can be one of the following:
The initial value specified in the Data Dictionary.
The last value set with either the DYNAMIC-CURRENT-VALUE statement or the DYNAMIC-NEXT-VALUE function.
The Unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.
Sequence values are stored in the database in which they are defined, and persist between each invocation of the DYNAMIC-CURRENT-VALUE statement or DYNAMIC-NEXT-VALUE function.
You cannot invoke the DYNAMIC-CURRENT-VALUE function from within a WHERE clause. Doing so generates a compiler error. To use a result from the DYNAMIC-CURRENT-VALUE function in a WHERE clause, assign the result to a variable, then use the variable in the WHERE clause.
You can use any combination of the DYNAMIC-NEXT-VALUE function, DYNAMIC-CURRENT-VALUE function, DYNAMIC-CURRENT-VALUE statement, and their static versions.

See also

CURRENT-VALUE function, CURRENT-VALUE statement, DYNAMIC-CURRENT-VALUE statement, DYNAMIC-NEXT-VALUE function, NEXT-VALUE function